﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

-- Update settings and filters for Full Text Search

EXEC sp_fulltext_service @action='load_os_resources', @value=1; 
EXEC sp_fulltext_service 'verify_signature', 0; 
EXEC sp_fulltext_service 'update_languages'; 

Exec sp_fulltext_service 'ft_timeout', 600000; -- ten minutes 
Exec sp_fulltext_service 'ism_size',@value=16; -- the max

EXEC sp_fulltext_service 'restart_all_fdhosts'; 
reconfigure with override

-- TODO: If Semantic Language Statistics Database is attached, it will return a count of one row from this query:
-- SELECT COUNT(*) FROM sys.fulltext_semantic_language_statistics_database
-- If it does, add Semantic Language Statistics to the full text index on the FileTable IOT allow semantic search
